
If Exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_Payment') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_Payment
END
GO
	CREATE VIEW V_Payment
	AS 
	SELECT Guid,PaymentType,NAME,MerchantCode,IsCOD,ForAdvancePayment,OrderID,IsPercent,Charge
	FROM ShopNum1_Payment
	WHERE IsDeleted=0

